
create external table jms_dm.dm_terminal_tran_direct_delivery_sign_sum_dt
(
end_provider_id          string COMMENT '省份id' ,
end_provider_name        string COMMENT '省名字' ,
end_agent_code           string COMMENT '代理区code' ,
end_agent_name           string COMMENT '代理区名字' ,
end_center_code          string COMMENT '末端中心code' ,
end_center_name          string COMMENT '末端中心名字' ,
end_city_id              string COMMENT '城市id' ,
end_city_name            string COMMENT '末端城市' ,
end_area_id              string COMMENT '末端区县id' ,
end_area_name            string COMMENT '末端区县' ,
final_sign_network_code  string COMMENT '规划签收网点code' ,
final_sign_network_name  string COMMENT '规划签收网点' ,
package_type             string COMMENT '包类型' ,
second_package_code      string COMMENT '二段吗' ,
third_package_code       string COMMENT '三段码' ,
waybill_sum              int COMMENT '运单量' ,
package_sum              int COMMENT '包数' ,
third_code_right_sum     int COMMENT '三段码准确的量' ,
arrival_send_sum         int COMMENT '一键到出量' ,
aging_sign_sum           int COMMENT '准点签收量' ,
ass_sum                  int COMMENT '错分量' ,
send_noarrival_sum       int COMMENT '有发无到总量' ,
center_send_sign_hours   string COMMENT '中心发发件时间到时效签收时间' ,
no_send_sign_cnt         string COMMENT '发签缺失量' ,
deliver_sign_hours       string COMMENT '派签时长' ,
deliver_sign_loss_cnt    int COMMENT '派签缺失量' ,
date_time                string COMMENT '业务日期',
end_franchisee_code string comment  '加盟商code',
end_franchisee_name string comment  '加盟商'
)
comment '转运直送签收维度汇总'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_terminal_tran_direct_delivery_sign_sum_dt'
TBLPROPERTIES (
    'discover.partitions' = 'false',
    'parquet.column.index.access' = 'true'
    );
